Creating a Change Processing task
You can create a CDC task by duplicating the Full Load task. This is useful if you currently have a Full Load task only and the need (which wasn't previously anticipated) arises to capture changes from all of the tables or only from certain tables.
To do this:
- Select the Full Load task in the left pane of the Manage Data Warehouse Tasks window and click the Duplicate toolbar button.
-
In the Duplicate <ETL_Set_Name> window, set the following properties:
- Task name - The name for the task (e.g. employees_changes).
- Select a landing zone - Select the same landing zone as the Full Load task.
- Schemas - Select the same schema as the Full Load task.
- Task type - Select Change Tables.
-
To only apply changes to selected tables, in the Mappings column, select the tables whose changes you want to apply to the data warehouse.
Information noteIf you want to modify a column's mapping, the table name displayed in the left pane of the Edit Mappings window will not be appended with the "__ct" suffix (which is the default naming format for Replicate Change Tables). However, the changes will still be taken from the associated Change Table.
Warning noteFor each Primary Key there is one record. Changing a Primary Key on the source record will cause a new record to be inserted in the data warehouse.
- Click Generate and wait for the task statements to be generated.
-
To capture the changes and apply them to the data warehouse, click Run.
Reloading data from the source tables to the Landing Zone
In cases of inconsistencies or when metadata from the source tables is not replicated to the Landing Zone, you may need to reload the data.
To reload data from the source tables:
- Run the Qlik Replicate Full Load replication task again.
-
Run the Compose for Data Warehouses Full Load storage task.
-
Continue running the existing Compose Change Processing task.
Information noteNo duplicates are created, as Compose compares the records before adding them to the Data Warehouse.
Warning noteRecords that should be deleted in the new Full Load task are not deleted nor marked for deletion (soft delete).